LinkBack URL
About LinkBacks
Probably simple...
I have an excel file that is a list of records, one after the other
Value | Data
Name | Joe
Phone | 123456
Name | Tom
Phone | 456789
(8000 pairs)
how to I change this to
Name|Phone
Joe |123456
Tom | 456789
Probably simple...
I have an excel file that is a list of records, one after the other
Value | Data
Name | Joe
Phone | 123456
Name | Tom
Phone | 456789
(8000 pairs)
how to I change this to
Name|Phone
Joe |123456
Tom | 456789
Last edited by everseeker; 11-20-2015 at 01:16 PM. Reason: Add subscription = yes
=IFERROR(IF(COLUMNS($A:A)<=2,INDEX($B$2:$B$21,COLUMNS($A:A)+(ROWS($1:1)-1)*2),""),"")
copy across two columns (in total) and down as far as needed.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Not quite. Here's the output of that attempt
2015-11-20_12-21-43.jpg
My formula did work with the sample that you posted originally. I am now totally confused. Rather than pictures of excel sheets, or unformatted text (where it's impossible to tell what is in what cell) - please post an excel sheet!!.
However, is it as simple as
=IFERROR(IF(COLUMNS($A:A)<=2,INDEX($c$2:$c$21,COLUMNS($A:A)+(ROWS($1:1)-1)*2),""),"")
this might be it - as there was no indication from your original post where your data actually started....
Last edited by Glenn Kennedy; 11-20-2015 at 02:12 PM.
... and when you post your Excel sheet, please show your expected results...
example.xlsxHere is a snip of my data (Result desired to the right)
Rather different from your original!!! Anyhow, this formula in E2, drag across and down.
=IFERROR(IF(COLUMNS($A:A)<=11,INDEX($A$2:$A$50,COLUMNS($A:A)+(ROWS($1:1)-1)*11),""),"")
Adjust the 50 to suit your data. Copy aross and down as far as needed. See sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks