Someone asked almost an identical question to what I have, but with one minor change and I can't seem to figure out how to accommodate that change.
Well, I tried to post the link but I can't since I'm a new user. The post has the exact same title as mine and I have the exact same question that the user in post #6 had.
Basically, I need a formula to move 4 repeating data sets into separate columns. Someone provided the answer/formula below, but I do not have the 5th empty row as they had. And I don't know how to 'fix' the formula to accommodate for the difference.
Assuming:
1) Data is in column A starting at A1 (no header)
2) Every 5th cell is blank
3) D1:G1 are the headers for you new table (First, Last, Number, Type)
Put this formula in D2, copy to the right and down until you start seeing zeros:
=INDEX($A:$A,ROW($A1)*5-4+COLUMN(A$1)-1)
My data:
(Jurisdiction)
(Search Fee)
(County Fee)
(Date)
(Jurisdiction)
(Search Fee)
(County Fee)
(Date)
(Jurisdiction)
(Search Fee)
(County Fee)
(Date)
(Jurisdiction)
(Search Fee)
(County Fee)
(Date)
What I need:
(Jurisdiction) (Search Fee) (County Fee) (Date)
(Jurisdiction) (Search Fee) (County Fee) (Date)
(Jurisdiction) (Search Fee) (County Fee) (Date)
Thank you!
Bookmarks