The specialty retail chain Annaâs Linens filed for bankrupty protection last month and is set to close all their stores, according to the Ariz. â¦. The specialty retail chain Annaâs Linens filed for bankrupty protection last month and is set to close all their stores, according to the Arizona Republic. . The Costa Mesa, Calif.-based company, founded in 1987, is closing its more than 200 stores in the United States and Puerto Rico.
Let us say you have a list of values in range A1:A5 and you want to reverse the list. In an empty cell write =INDEX($A$1:$A$5,6-ROWS($A$1:A1)) and copy down. Boom, you get the reversed list. In the reversed list, first item is last item in the original list (ie 5th item in our case).
1. Copy the rows you want to convert to columns (or columns to be converted to rows). 2. Select an empty cell in the same or another worksheet. 3. Open the Paste Special dialog, as explained in the previous solution and select Paste Link in the lower left-hand corner of the dialog window. On the, click the little black arrow below the Paste button, and select Transpose. 2  Right click the destination cell and choose Paste Special from the context menu, then select Transpose. 3  And finally, the fastest way is to press CTRL+ALT+V, select Transpose and click OK.