Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bring data from header fields to the columns
Hi all,
I need help on automating the following: everyday I get as EXCEL report in the format as described below title1: abc title2: xyz 1 Name1 Id1 Qty1 Cust1 Diff1 2 Name2 Id2 Qty2 Cust2 Diff2 3 Name3 Id3 Qty3 Cust3 Diff3 ... ... title1: pqr title2: def 1 Name4 Id4 Qty4 Cust4 Diff4 2 Name5 Id5 Qty5 Cust5 Diff5 the number of records under each title1 and title2 vary each day. I would like to have the output as below: 1 abc. xyz. Name1 Id1 Qty1 Cust1 Diff1 2 abc. xyz. Name2 Id2 Qty2 Cust2 Diff2 3 abc. xyz. Name3 Id3 Qty3 Cust3 Diff3 4 pqr. def. Name4 Id4 Qty4 Cust4 Diff4 5 pqr. def. Name5 Id5 Qty5 Cust5 Diff5 that is I want the output to be nicely arranged in the columns with the title1 and title2 info also captured in the columns as opposed to as headers. Again the length of the report varies and also the number of records within each title1 & title2. Can someone please help me with a code to automate this task? Thanks a lot in advance for looking into this. Regards, ag |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to print one header over several columns of data | Excel Discussion (Misc queries) | |||
Formula to bring in the header | Excel Worksheet Functions | |||
Bring fields from header to columns | Excel Programming | |||
how can I convert data with fields in rows to fields as columns | Excel Discussion (Misc queries) | |||
compare two columns data and bring them to another work sheet | Excel Discussion (Misc queries) |