BusinessHack
New Member
- Joined
- Apr 10, 2016
- Messages
- 7
Hi All,
I had no luck in finding a solution so apologies in advance if this has been asked before.
I have text data in Sheet 1 and need each row to be copied to Sheet 2 under the correct column based on the heading.
The data will not be sorted alphabetically in Sheet 1.
Some cells in Sheet 2 will be blank and every now and then a new column heading will be added.
Thanks in advance.
I had no luck in finding a solution so apologies in advance if this has been asked before.
I have text data in Sheet 1 and need each row to be copied to Sheet 2 under the correct column based on the heading.
The data will not be sorted alphabetically in Sheet 1.
Some cells in Sheet 2 will be blank and every now and then a new column heading will be added.
Thanks in advance.
Book2 | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | |||
1 | Business | ABC | Aisle | Astro Boy | BYO | Canadian Stars | Enforce | Friday | Goodluck | Honda | JA Rule | Jolly Santa | Lane | Leg | Long Reach | Praise | Q Tips | RAP Group | RNB | Selecta | Solataire | Stay Power | Sunday | Sungrass | Tetris Player | Trinadad | Window | Zebra | ||
2 | Company A | |||||||||||||||||||||||||||||
3 | Company B | |||||||||||||||||||||||||||||
4 | Company C | |||||||||||||||||||||||||||||
5 | Company D | |||||||||||||||||||||||||||||
Install |