I want to paste a data from Excel to Google Sheet. Current data in column is 2022 to 2017 (column B to G), and I just want to get the data in column as 2017 to 2022. I want just paste the new data and the data arranged in the 2017 to 2022.
You can use the CHOOSECOLS function
=CHOOSECOLS(A:G,7,6,5,4,3,2,1)
Or if you want it dynamic
=CHOOSECOLS(A:G,SEQUENCE(COLUMNS(A:G),1,-1,-1))