12learnexcel
New Member
- Joined
- Aug 3, 2009
- Messages
- 7
Hi everyone. I've been searching for a thread about this query but all I found refer to Multiple Rows to Single Columns and the like.
I need help in transposing Several Rows into Multiple Columns and I would appreciate if it's in a formula format and not VBA.
The table looks like this:
<tbody>
</tbody>
Please note that the Sale number extends up to 20 and the Products are up to 200.
I need it to look like this on another worksheet:
<tbody>
</tbody>
I've been trying to research about this and work it out myself but my deadline is fast approaching. Thanks everyone in advance for your help.
I need help in transposing Several Rows into Multiple Columns and I would appreciate if it's in a formula format and not VBA.
The table looks like this:
Product | Detail | Sale | ||||
1 | 2 | 3 | 4 | 5 | ||
Product 1 | Date of Sale | A1 | A2 | A3 | A4 | A5 |
Client Name | B1 | B2 | B3 | B4 | B5 | |
Quantity | C1 | C2 | C3 | C4 | C5 | |
Price / Pc | D1 | D2 | D3 | D4 | D5 | |
Product 2 | Date of Sale | A6 | A7 | A8 | A9 | A10 |
Client Name | B6 | B7 | B8 | B9 | B10 | |
Quantity | C6 | C7 | C8 | C9 | C10 | |
Price / Pc | D6 | D7 | D8 | D9 | D10 | |
Product 3 | Date of Sale | A11 | A12 | A13 | A14 | A15 |
Client Name | B11 | B12 | B13 | B14 | B15 | |
Quantity | C11 | C12 | C13 | C14 | C15 | |
Price / Pc | D11 | D12 | D13 | D14 | D15 |
<tbody>
</tbody>
Please note that the Sale number extends up to 20 and the Products are up to 200.
I need it to look like this on another worksheet:
Consolidated Sales List | |||||
Product | Date of Sale | Client Name | Quantity | Price / Pc | |
Product 1 | A1 | B1 | C1 | D1 | |
Product 1 | A2 | B2 | C2 | D2 | |
Product 1 | A3 | B3 | C3 | D3 | |
Product 1 | A4 | B4 | C4 | D4 | |
Product 1 | A5 | B5 | C5 | D5 | |
Product 2 | A6 | B6 | C6 | D6 | |
Product 2 | A7 | B7 | C7 | D7 | |
Product 2 | A8 | B8 | C8 | D8 | |
Product 2 | A9 | B9 | C9 | D9 | |
Product 2 | A10 | B10 | C10 | D10 | |
Product 3 | A11 | B11 | C11 | D11 | |
Product 3 | A12 | B12 | C12 | D12 | |
Product 3 | A13 | B13 | C13 | D13 | |
Product 3 | A14 | B14 | C14 | D14 | |
Product 3 | A15 | B15 | C15 | D15 |
<tbody>
</tbody>
I've been trying to research about this and work it out myself but my deadline is fast approaching. Thanks everyone in advance for your help.