Sheets question

[IMANUT46]

It's been years since I have created a spreadsheet.
Without planning the structure, I created a sheet to contain dates and values. Without thinking, I just entered the data. I should have listed the dates in the left column, and the values across the top. Instead, I reversed it.
Is there an easy way to do reverse the sheet without reentering the data? Thanks.

 

[Javier P]

Do you mean something like in my first screenshot? If so, that's quite easy. Select the whole table, long press and Copy. Go to an empty cell below, long press, Paste special and select Paste transposed.

 

[IMANUT46]

Thanks. Very interesting. I'll give it a try when I get some quiet time.

 

[Javier P]

Thanks. Very interesting. I'll give it a try when I get some quiet time.

Did it work?

 

[IMANUT46]

Do you mean something like in my first screenshot? If so, that's quite easy. Select the whole table, long press and Copy. Go to an empty cell below, long press, Paste special and select Paste transposed.
View attachment 338813View attachment 338814

No, I couldn't get to the PASTE TRANSPOSED.

 

[Javier P]

No, I couldn't get to the PASTE TRANSPOSED.

Strange. Which options you get in Paste Special? Did you copy the whole table?

 

[IMANUT46]

Strange. Which options you get in Paste Special? Did you copy the whole table?
View attachment 339038

I copied the table and it seemed when the new sheet appears, in a few seconds later, an error message appears. Screenshot attached.

 

[B. Diddy]

In case this has anything to do with the altered DPI setting (as discussed in your other thread about the Accessibility shortcut), I think it would be ideal if you changed the DPI back to the default, then see if these problems persist.

 

[IMANUT46]

OK. I returned to the Devopers Option . It shows 320 DPI as the smallest. In that same area, there is a setting RETURN TO DEFAULT SETTINGS. I have followed this threads advice and disabled Developers Option.
How do I find the default DPI Setting?

 

[Javier P]

I copied the table and it seemed when the new sheet appears, in a few seconds later, an error message appears. Screenshot attached.

I'm not sure what you mean. It seems that you finally managed to transpose the table and place the dates in the first column, right?

About that error. There are different possible causes (some error in the copy process, the sheet being accessed from different devices at the same time, some cells with corrupted data, etc). It's impossible to know for sure what happened in your case. Are you accessing that sheet from a browser as well?

Usually the fix is making a copy of the original file and make all edits in this copied sheet.

About the Smallest Width. Please, see your other thread where I explained how it works and the default values for the Pixel 3 series.

 

[B. Diddy]

OK. I returned to the Devopers Option . It shows 320 DPI as the smallest. In that same area, there is a setting RETURN TO DEFAULT SETTINGS. I have followed this threads advice and disabled Developers Option.
How do I find the default DPI Setting?

Lower DPI means everything on the screen looks bigger. According to the web, the default DPI for the Pixel 3 and 3 XL is 440, so try changing to that.