Re arrange excel data.
All,
I have to re arrange a huge data which is in 240*2000. iam giving the present data format below and the expected output format too. please please some body help. sos.
Present form of the data:
ID NUMBER 05-07-2010 06-07-2010 07-07-2010
55827 1 5 1
55832 2 12 0
55813 3 100 0
55826 1 0 5
55828 0 252 0
55840 3 20 0
55829 6 20 5
expected output of the data:
ID NUMBER AMOUNT DATE
55827 1 05-07-2010
55832 2 05-07-2010
55813 3 05-07-2010
55826 1 05-07-2010
55828 0 05-07-2010
55840 3 05-07-2010
55829 6 05-07-2010
55827 5 06-07-2010
55832 12 06-07-2010
55813 100 06-07-2010
55826 0 06-07-2010
55828 252 06-07-2010
55840 20 06-07-2010
55829 20 06-07-2010
55827 1 07-07-2010
55832 0 07-07-2010
55813 0 07-07-2010
55826 5 07-07-2010
55828 0 07-07-2010
55840 0 07-07-2010
55829 5 07-07-2010
| Attachment | Size |
|---|---|
| A.xlsx | 9.51 KB |
- prem.winsome's blog
- Login or register to post comments
- 3456 reads
help
some one please help me.. its very urgent
Solution
For the solution to your problem visit the url
http://excelexperts.com/transpose-back
data manipulation
hi Prem
I can get something to you by tomorrow..
Request a quote
Nick
hi
nick,
please help me with this issue. i have it on my head.
Data analysis
the answer to your issue depends on whether this is a one-off request, or you need to repeat many times.
If the latter, you need a VBA solution or you will spend all your time manipulating data.
If the former, simply replicate the ID numbers for how ever many days you have, and cut and paste the data into the right place.
hi
Nick,
total rows i have in my excel are 2000 and with columsn 250. it is merely not possible to cut/copy/paste. hence please help me with any vba solution.
thx