un-consolidating a list

  • Thread starter Thread starter Aaron C
  • Start date Start date
A

Aaron C

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
 
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
 
Back
Top