transpose of 3 rows

**Fotis1991** · 08-16-2012, 07:33 AM

Hi

I have a "strange" isue in the Greek forum and i need help on this.

Op has 3 rows of data for the same person and needs to transpose all data for eatch person in a single row.

Any idea?

**jindon** · 08-16-2012, 08:18 AM

Try

Please Login or Register  to view this content.

**Fotis1991** · 08-16-2012, 08:31 AM

Thank you very mutch for this code but i know NOTHING at all, about VBA.

So i don't use VBA or Macro in my worksheets.

Let's hope that someone will have a formulae solution for this.

Once again, Thank you.

**rvasquez** · 08-16-2012, 09:16 AM

Hello there,

I understand the hesitation with using VBA and macros as they can be hard to understand but with this kind of request it might be a little easier to just add the code once to your worksheet and then be done with it. If you'd like I've provided a code below that has comments explaining what each line of code does and then instructions on how to use it in your workbook.

The code:

Please Login or Register  to view this content.

How to use it:

1. Move the worksheet you would like to format so that it is the first worksheet in your workbook then Press Alt+F8 on your keyboard (this will bring up the macro window)
2. Clear the macro name field and then type the word UniqueValues
3. That will be the name for the macro you are creating
4. Select the Create option
5. In between the Sub UniqueValues( ) and End Sub copy and paste the above code I provided you.

6. The entire code once you've copied and pasted should look like this:

Please Login or Register  to view this content.

6. Here, anything that appears in green is a comment meant to help you understand what the code it doing.
7. Close out of the Visual Basic Window
8. Press Alt+F8 on your keyboard
9. This time select the UniqueValues macro and then select run.

Let me know if this works for you, I understand if you still do not wish to use VBA.

Thanks!

**Marcol** · 08-16-2012, 09:19 AM

See if this workbook helps, or at least gives you a start, I haven't fully checked it, you might get 0 returned if the original cell is blank.

**Fotis1991** · 08-16-2012, 10:06 AM

@ rvasquez

Thank you, FOR YOUR TIME AND YOUR EFFORD.! Your code and your instuctions are very good and i promise to study these! Good opportunity to start learning VBA!

@ Marcol.

I did not thought to use dates in row 2. Everything works Ok.Ilet you know if a have some other problem on this!

Thank you!