Home Transpose values from specific multiple columns to specific rows with conditions
Reply: 0

Transpose values from specific multiple columns to specific rows with conditions

motorkey
1#
motorkey Published in 2018-02-14 16:17:44Z

I've been searching about this problem, testing a lot of options and scripts, but I couldn't find a way to solve the problem.

I need:

1) Read/copy the values from specific interval/range by ID;

2) Transpose the values and paste in a specific column;

3) After data transpose must be created a new worksheet - new data format.

Explain:

  • The metric is months by kilometers;

  • The months is from 24 months to 60 months with intervals of 8 (exception from the last one). i.e. 24/16 to 24/80, 36/16 to 36 80 until 60/80.

  • The kilometers is from 16km to 80km (interval each 8km).

  • I have to read a range of 9 values (24/16, 24/24,... 24/60) and transpose it to specific column, where this column correspond to specific month (example 24 month).

  • The values are distributed in columns, but all of them in one line.

  • A loads of functions and macros at main table.

There are other options to do that, but for the moment the best way is using VB at Excel, that I couldn't get until now. I think the best way is (in loop) get the values in interval of 9, put in arrays, transpose and paste in the correct column.

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.329917 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO