View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jose Jose is offline
external usenet poster
 
Posts: 35
Default Transposing One Column to Multiple Rows

I have One Column of Monthly Hourly data, i.e., 24 hours each for 28, 30, 31
Days. I would like to transpose this data into Rows for Days and Columns for
Hours, i.e., 28, 30, 31 Rows by 24 Columns. Can someone please help me?

--
Thanks In Advance for Sharing Your Knowledge!