Hello support group,
Here is my issue. I have a file in this format with cities in column A and then count across other columns
Name Q116 Q216 Q316 Q416 Q117 Q217 Q317 Q417
city1 10 20 30 40 50 60 70 80
city2 1 2 2 2 2 3 4 5
I need my new sheet like this
city1 Q116 10
CITY1 Q216 20
CITY1 q316 30
city1 q416 40
city1 q117 50
city1 q217 60
city1 q317 70
city1 q417 80
..... same for city 2
Please help!
Thanks in advance,
Shravani
Maybe attach a workbook with a before and after.
Sanitize, no personal info, before attaching
i created a new post with attachment
http://www.excelforum.com/showthread...50#post4495250
Are you OK with a formula:
In L2
=OFFSET($A$2,INT(ROWS($L$2:L2)-1)/8,,,)
In M2
=OFFSET($B$1,,MOD(ROWS($M$2:M2)-1,8),,)
In N2
=OFFSET($B$2,INT(ROWS($N$2:N2)-1)/8,MOD(ROWS($N$2:N2)-1,8),,)
All copied down.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thank you Glenn!
Formula works for me
Thanks,
Shravani
Thank you Glenn!
Formula works for me
Thanks,
Shravani
Great! I'm glad to have helped! If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
Last edited by Glenn Kennedy; 10-04-2016 at 03:03 PM.
Using code try this
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Yasser
I would change these 2 lines
toPlease Login or Register to view this content.
to keep it more flexible.Please Login or Register to view this content.
and if you want slightly less looping
Please Login or Register to view this content.
That's great Mr. Jolivanes
Thanks for this helpful solution
Best Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks