What I'm trying to do seems simple but not when I try to 5K unique IDs. I have 5k hospitals all in row format. Each hospital has procedural volumes (counts) for 33 different procedures, with the procedures in column format. Example in first screenshot below.
What I need to do is convert the rows to columns, but have that repeat for the 5K unique hospitals and 33 unique procedures with the procedures now in rows. Result would be example in screenshot 2 below. Any suggestions? Thank you!
Hi Sharonb, sorry- doesn’t work with pivots. A vba procedure will work. Pls. Check this site for excel vba best practice: www.yexcel.de, they also got many vba tutorials and scenarios in english, French, Spanish... hope that helps. Greets, Eva