I have a list with entries in one column like this:
sourceText
empty cell
targettext
sourceText2
category2
targettext 2
and I want to change it like this:
sourceText empty cell target text
sourceText2 category2 target text 2
Attached sample data. Sheet one as it is. Sheet 2 as I want them to be (I don't need any of the formatting in Sheet 2).
Last edited by greek; 10-29-2009 at 06:27 PM.
Could you not use copy, paste special and select transpose?
That puts all the data in one row... like this:
sourceText empty cell target text sourceText2 category2 target text 2 [...]
Tried this
http://support.microsoft.com/kb/214024
but it gave me an error (The formula you typed contains an error).
Last edited by greek; 10-29-2009 at 05:52 PM.
Solution found, I replaced commas with ; in that formula and it worked.
=OFFSET($A$1;(ROW()-1)*4+INT((COLUMN()-3));MOD(COLUMN()-3;1))
Last edited by greek; 10-29-2009 at 06:33 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks