As i am working in travel industry, we have different categories of seating layout example 2X1 & 2X2 seating layout, i need to transpose my data into seating layout so for that i need macro codes before running the program it should ask whether you need seating layout is 2X1 or 2X2 after selecting one the data to transpose according to selected. Kindly refer to the excel sheet attached.