Home can I get row data to column data?

[HockeyDiablo]

Home can I get row data to column data? The information can only be whats listed on the top of the instance. Each instance is separated by a blank row (10,20)

I will provide 3 instances as a reference.

[/IMG]

 

[sheetspread]

If each change has Customer name two rows above, you can write a conditional formula that prints either the new or previous name. Also require a number to exist in the next column instead of blank or text (if the pattern holds).

 

[tonyyy]

HockeyDiablo,

If you're comfortable with a vba approach, you might try the following...

Sub Row2Column()
Dim LastRow As Long
Dim r As Range, d8 As Range, Customer As Range

LastRow = Cells(Rows.Count, "A").End(xlUp).Row
For Each r In Range("A4:A" & LastRow + 1)
    If Application.CountA(r.EntireRow) = 0 Then
        Set d8 = r.End(xlUp).End(xlUp)
        Set Customer = d8.Offset(0, 1)
        d8.Offset(-3, 3) = d8.Value
        Customer.Offset(-1, 2) = Customer.Value
    End If
Next r
End Sub

Cheers,

tonyyy

 

[HockeyDiablo]

I see where your going with this but still cant get it to run, 400 error

 

[FDibbins]

I am unable to see your pic, can you paste a sample of what you have - and what you want, here please?

(have you tried the Copy/Paste Transpose function?)

 

[HockeyDiablo]

here is a URL of a screenshot

http://www.screencast.com/t/4KGUjvyqbM00

This is after I insert 2 rows (A,B) Its where I would like to place the originating data

 

[sheetspread]

Can you paste data we can copy? Here's 1 way:

https://onedrive.live.com/?id=8CFFDEC0CE27E813!189&cid=8CFFDEC0CE27E813 (download the second folder)

https://www.youtube.com/watch?v=JycvgGppxt0&feature=youtu.be (installation guide)

The solution is very simple once we have a sample

 

[Rick Rothstein]

here is a URL of a screenshot

05.27.2016-15.57.40 - JamesStruss7324's library

This is after I insert 2 rows (A,B) Its where I would like to place the originating data

A and B are columns, not rows... did you mean to say you inserted two columns?

Also, so the values in Column C already exist and is the wording pattern shown consistent all the way down?

Also, it is hard to tell from your picture, but is there a dash in cells C3, C13, C23, etc.?

 

[HockeyDiablo]

https://drive.google.com/open?id=0BxMHH822lN3KTklyRndRM0l1bjA
https://drive.google.com/open?id=0BxMHH822lN3KbUxtZkJJV3ZhZnc

Try this out

 

[HockeyDiablo]

I did mean rows, my apology... The position of the "-" and "work date" remain consistent, I need only the data to the right of that in each respective column.