• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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