Hello,
I have over 8,000 of these continuous information. Looking at the screenshot you will see the 'Day' column. 1 is Monday, 2 is Tuesday, 3 is Wednesday, and so on. I need to get the times to transpose into one row for each store ID. Instead of having seven store ID's, I need one store ID per a row. There would be 14 Columns total per a Store ID because there are seven days and Open and Close for each day. Is there a way to quickly do this?
Thank you so much!
Bookmarks