ExcelNewbie2020
Active Member
- Joined
- Dec 3, 2020
- Messages
- 299
- Office Version
- 365
- Platform
- Windows
Sirs,
I have multi-column data which was arranged horizontally and vertically. If it is possible, the multi-column can be transferred to 2 columns to be arranged vertically.
For better understanding of my issue. please find the attached sample file.. Thank you in advance.
I have multi-column data which was arranged horizontally and vertically. If it is possible, the multi-column can be transferred to 2 columns to be arranged vertically.
For better understanding of my issue. please find the attached sample file.. Thank you in advance.
sample.xlsx | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | |||
1 | RESULT | |||||||||||||||||||||||
2 | INPUT DATA | Date | Amount | |||||||||||||||||||||
3 | Name | Date | Amount | Date | Amount | Date | Amount | Date | Amount | Date | Amount | Date | Amount | Date | Amount | Date | Amount | 05-07-19 | 2,000.00 | FORMULA HERE | ||||
4 | Name 1 | 05-07-19 | 2,000.00 | 10-23-19 | 3,000.00 | 04-05-19 | 2,000.00 | 05-08-19 | 6,000.00 | 07-08-19 | 9,500.00 | 07-30-19 | 10,000.00 | 07-07-19 | 2,500.00 | |||||||||
5 | Name 2 | 07-07-19 | 2,500.00 | 06-22-19 | 2,500.00 | 11-21-19 | 2,500.00 | 08-15-19 | 9,500.00 | 03-31-19 | 2,000.00 | |||||||||||||
6 | Name 3 | 03-31-19 | 2,000.00 | 12-11-19 | 2,000.00 | 01-06-19 | 6,000.00 | 07-21-19 | 2,500.00 | 10-10-19 | 2,500.00 | |||||||||||||
7 | Name 4 | 12-24-19 | 2,000.00 | 12-19-19 | 2,500.00 | 08-26-19 | 2,500.00 | 07-12-19 | 2,500.00 | |||||||||||||||
8 | Name 5 | 06-17-19 | 2,500.00 | 06-01-19 | 2,000.00 | 10-11-19 | 2,500.00 | 08-23-19 | 2,500.00 | 11-13-19 | 10,000.00 | 12-26-19 | 2,500.00 | |||||||||||
9 | Name 6 | 12-15-19 | 5,000.00 | 09-30-19 | 3,000.00 | 09-28-19 | 6,000.00 | 02-25-19 | 2,500.00 | 01-19-19 | 10,000.00 | 08-15-19 | 10,000.00 | |||||||||||
10 | Name 7 | 05-16-19 | 5,000.00 | 04-01-19 | 2,500.00 | 11-17-19 | 10,000.00 | 05-19-19 | 6,000.00 | |||||||||||||||
11 | Name 8 | 04-06-19 | 3,000.00 | 03-14-19 | 6,000.00 | 10-30-19 | 2,500.00 | 07-05-19 | 6,000.00 | 05-01-19 | 10,000.00 | |||||||||||||
12 | ||||||||||||||||||||||||
13 | ||||||||||||||||||||||||
14 | ||||||||||||||||||||||||
15 | *ALL DATA IN BLUE COLOR CELLS (INPUT DATA) WILL AUTOMATICALLY TRANSFER TO RESULT COLUMN | |||||||||||||||||||||||
16 | * MUST BE GROUP BY DATE & AMOUNT | |||||||||||||||||||||||
17 | ||||||||||||||||||||||||
18 | ||||||||||||||||||||||||
19 | ||||||||||||||||||||||||
20 | ||||||||||||||||||||||||
21 | ||||||||||||||||||||||||
Sheet2 |