I have one table with header as Field Name and the values in the column as First Name, Last Name and Address. I want to create another table with values from that column. So another table will have header as First Name, Last Name, etc. And I will be adding rows of data in another table then. Is this possible?
You could copy and paste the names one by one as you make new fields in the second table, but there’s no way to automatically take field data from a bunch of records in one table and turn them into field labels in another. The row of field headers may look like a stylized header row in a spreadsheet, but it’s structurally very different. Field headers can only be manually modified, and only individually.
This sounds very strange to me, what are you trying to achieve? Could you give us more information, even screenshots?