Table manupulations. From colum to row

Hi Ranjit,

Welcome to the Forum

Try this:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

If you haven't used macros before you'll need to go to:
File- options - trust center -trust center settings - macro settings ,
the second option down (disable all macros with notification)

Then - Copy the code to the clipboard

Open your Workbook

Press ALT + F11 to open the Visual Basic Editor.

Select "Module" from the Insert menu

Type "Option Explicit" then paste the code under it

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name

Originally Posted by ranjit.khatri094

I have a table. part of it is shown below. These are the trip GPS cordinates for each trips by different users.

Attachment 395388

I want this to be simple, ready to use in other applications which is shown as below.

Attachment 395389

I have a huge dataset. So, I would be glad if you could help me with the automated process, probably using the code.

Thank you

I am unable to view your pictures, though they aren't the best way to get help here.

Attach a sample workbook instead. Make sure there is just enough data to demonstrate your need. Use a BEFORE sheet and an AFTER sheet in the workbook to show the process you're trying to complete or automate.

Remember to desensitize the data if necessary.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

I found a way to finally see your pics... so something like this:

Please Login or Register  to view this content.

Thank you for the reply.

Hi Ranjit,

You're welcome and thanks for the rep!

This will put the User and Trip on every line

Please Login or Register  to view this content.

This works perfectly well for the small files, I guess. However, when I try to run it for the whole dataset, I get some error "Runtime Error 1004-Application defined or object defined error". I would be glad if you could help me with this. (You have helped me a lot with this solution already). I am planning to do this piece by piece if there is no other way.
:-)

After 5 minutes: I found that there is one outlier in the table. I deleted that and now it works well. PROBLEM SOLVED

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Hi Ranjit,

All I could think was that it might be overflow and I was going to suggest that you use Jerry's code in post #4 - Glad that you found the problem