SOLVED
How to copy column name to first row?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
JJJJC
7 - Meteor
‎08-26-2021
08:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How can I copy column names of a table to first row so that when I try to stack (union) it with another table on same excel sheet, I can still see the column names?
Solved! Go to Solution.
6 REPLIES 6
Emil_Kos
17 - Castor
‎08-26-2021
08:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
atcodedog05
22 - Nova
‎08-26-2021
08:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎08-26-2021
08:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
input1:
header1 | header2 |
A | 1 |
B | 2 |
input2:
header3 | header4 |
x | 3 |
z | 4 |
expected output:
header1 | header2 |
A | 1 |
B | 2 |
header3 | header4 |
x | 3 |
z | 4 |
Currently, when I try to union the two table by position, I would lose header3 and header4.
atcodedog05
22 - Nova
‎08-26-2021
08:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎08-26-2021
08:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you both!
atcodedog05
22 - Nova
‎08-26-2021
08:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @JJJJC
Cheers and have a nice day!