Jemworks77
New Member
- Joined
- Jul 30, 2007
- Messages
- 6
Hi Folks, I am pretty much new here, been cracking my head for the past few days trying to figure out a formula to do this hit on Google and found this board. What I would like to do is to move data from Horizontal to Vertical based on Column A. Whereby identical data in column A will be merge. It does not have to be on the same sheet, I am not to sure if this is possible with formula. Kindly refer to the screencap below which pretty much explains everything.
Would really appreciate if someone could help me, TQ
Would really appreciate if someone could help me, TQ
Test.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | JobNumber | Charge | Amount | FromThis | ||||
2 | KLX01 | THC | 100 | |||||
3 | KLX02 | Others | 80 | |||||
4 | KLX02 | THC | 10 | |||||
5 | KLX02 | GST | 20 | |||||
6 | KLX03 | THC | 20 | |||||
7 | KLX03 | Others | 10 | |||||
8 | KLX04 | GST | 60 | |||||
9 | ||||||||
10 | ||||||||
11 | JobNumber | THC | GST | Others | ToThis | |||
12 | KLX01 | 100 | ||||||
13 | KLX02 | 10 | 20 | 80 | ||||
14 | KLX03 | 20 | 10 | |||||
15 | KLX04 | 60 | ||||||
Sheet1 |