• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

Transpose Hundreds Of Columns

I currently have an ID field in Column A, a Date/Time field in column B and from column C onwards (It varies every week but this week it goes up to column GA). What I would like is for 3 columns of data, but the id and date/time needs to be associated with each new row. hope this makes sense
0
bryanscott53
Asked:
bryanscott53
  • 5
  • 5
1 Solution
 
nutschCommented:
Hi Bryan,

You can use my add-in. Select cell B2 (if you have headers in row 1, otherwise put them) and run.

Thomas
Table2DB.xla
0
 
bryanscott53Author Commented:
Hi nutsch i tried this but it stops at the following

 Set rngRowHead = .Range(.Cells(clRow, rngCol), .Cells(rngRows + rngRow - 1, clCol - 1))

any ideas
0
 
nutschCommented:
what's the error message you get?
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
bryanscott53Author Commented:
it is

Runtime error 1004

application-defined or object defined-error
0
 
nutschCommented:
Could you load a sample file?
0
 
bryanscott53Author Commented:
thanks, I have had to make up some dummy data hope this is OK, (It does reflect actual info sample.xlsx
0
 
nutschCommented:
It worked for me, selecting c2 as the data start

Check screencast

Thomas
nutsch-518128.flv
0
 
bryanscott53Author Commented:
You are right, i was not using it correctly. apologies this is awsome!
0
 
bryanscott53Author Commented:
saved me days of manual effort!!
0
 
nutschCommented:
Glad to help. It saved me lot of time again and again too. That's why I made it into an add-in.

Thomas
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now