un-consolidating a list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Aaron C - 23 Nov 2007 20:43 GMT

Hi all,
I have a PDF document that has 4 columns: Line number, Employee
Number, Last Name, First Name.

When I export this, I get a document that has one column, in the
following pattern, once per page:

Line Number
1
2
3
Employee Number
1
2
3
Last Name
Smith
Jones
Williams
First Name
Joe
Bob
Walter
Page x of y

Is there an easy way to put that back into columns and rows?

I'm doing it by hand this time, but I have this issue more and more.
Any help is appreciated.

Thanks,
Aaron C

Reply to this Message

Max - 25 Nov 2007 07:19 GMT

One play to try ..

Assuming source data in A1 down, in a repeating pattern of 16 lines per
group, followed by a break line: Page x of y, then the next 16 lines per
group, with the next break line, and so on ..

Place this in B1:
=OFFSET(INDIRECT("A"&INT((ROWS($1:1)-1)/4)*17+1),COLUMNS($A:A)*4-4+MOD(ROWS($1:1)-1,4),)
Copy B1 across by 4 cols to E1, fill down as far as required to populate

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Hi all,
> I have a PDF document that has 4 columns: Line number, Employee
[quoted text clipped - 28 lines]
> Thanks,
> Aaron C

Reply to this Message