Hi all,
I'm facing an issue where data comes in sections according to title and then has items associated with that header.
I would like to paste it into a table as follows with spaces in between.
Is there also any way to concatenate the headers with a space in between?
I would greatly appreciate any assistance with this.
Thank you.
I'm facing an issue where data comes in sections according to title and then has items associated with that header.
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Code | Description | QTY | Price | GST | Total | |||
2 | Section | 1 | |||||||
3 | 16875 | Paper | 324234 | 1 | 2 | 3 | 4 | ||
4 | 16876 | Paper | 324234 | 1 | 2 | 3 | 4 | ||
5 | 16877 | Paper | 324234 | 1 | 2 | 3 | 4 | ||
6 | 16878 | Paper | 324234 | 1 | 2 | 3 | 4 | ||
7 | 16879 | Paper | 324234 | 1 | 2 | 3 | 4 | ||
8 | 16880 | Paper | 324234 | 1 | 2 | 3 | 4 | ||
9 | Section | 2 | |||||||
10 | 16876 | Paper | 42384 | 5 | 4 | 8 | 1 | ||
11 | 57532 | Rock | 1230 | 7 | 1 | 6 | 8 | ||
12 | 56621 | Rock | 1235 | 8 | 2 | 5 | 9 | ||
13 | Section | 3 | |||||||
14 | 5412 | Scissors | 5121 | 5 | 6 | 4 | 5 | ||
15 | 2132 | Scissors | 212 | 12 | 2 | 5 | 21 | ||
16 | 54 | Scissors | 548 | 58 | 3 | 3 | 1 | ||
Sheet1 |
I would like to paste it into a table as follows with spaces in between.
Book1 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Section | Code | QTY | Price | GST | Total | |||||
2 | Section 1 | 16875 | 1 | 2 | 3 | 4 | |||||
3 | Section 1 | 16876 | 1 | 2 | 3 | 4 | |||||
4 | Section 1 | 16877 | 1 | 2 | 3 | 4 | |||||
5 | Section 1 | 16878 | 1 | 2 | 3 | 4 | |||||
6 | Section 1 | 16879 | 1 | 2 | 3 | 4 | |||||
7 | Section 1 | 16880 | 1 | 2 | 3 | 4 | |||||
Sheet2 |
Is there also any way to concatenate the headers with a space in between?
I would greatly appreciate any assistance with this.
Thank you.