Select a blank cell and type this formula =INDEX($A$1:$A$8,ROWS(A1:$A$8)) into it, press Enter key, then drag the autofill handle to fill this formula down until there appears duplicate order data. If you are familiar with formula, here I can tell you a formula to reverse the order of a column data.ġ. Tip: You can remove the help column if you do not need it any more. Now both help column and data column are reversed in order. In the Sort Warning dialog, check Expand the selection, and click Sort. Then click Data > Sort Largest to Smallest.
Then select the number cells and drag the autofill handle down until the number of cells is same as the number of data cells. Click at a cell next to your first data, and type 1 into it and go down the next cell type 2. You can create a help column besides your data, and then sort the help column to help you reverse the data.ġ. Here I introduce some quick ways to flip them upside down in a short time.įlip data upside down with help column and Sortįlip data upside down with Kutools for Excel If you type them one by one in a new order, this will be time-consuming. In some special cases, in the Excel work, we may want to flip our data upside down, which means to reverse the order of a column data as below screenshot shown. Other possibilities include previous patrons and owners of the property during the late 1800’s and early 1900’s or that it’s Jourdan trying to get across to the other side or desperately trying to communicate with mortals he considers to be his family.How to quickly flip data upside down in Excel? Perhaps some servants stayed behind to take care of him and go downstairs to throw glasses to release some angst. Three times since March of 2001, glasses have flown from behind the bar 12 feet across to the brick wall and shattered. We also have a slightly mischievous ghost in our Courtyard Bar that roams the property. Pierre Antoine Lepardi Jourdan never left his true love and home in New Orleans he continues to reside here to this day.Īlthough Jourdan is considered to be our main resident, he’s not the only spirit amongst us. Patrons and employees of Muriel’s have also witnessed objects being moved around throughout the restaurant. Our Seance Lounges on the second floor are named as such because it is believed that this is where Jourdan spends the majority of his time. His ghost doesn’t appear in human form, but instead as a glimmer of sparkly light wandering around the lounge. Pierre Antoine Lepardi Jourdan is still with us today in spiritual form on the same piece of property that is now Muriel’s. The shock of the loss was so intense that before having to vacate the premises and hand over his beloved treasure, he tragically committed suicide on the second floor in the same area where Muriel’s Seance Lounges are situated today. In 1814 he wagered his beloved home in a poker game and crushingly lost the one thing he treasured most in life. Although Jourdan dearly adored his beautiful home, he was a man that could never quench his thirst for the thrill and excitement of gambling. Pierre Antoine Lepardi Jourdan built his dream home, restoring it to the original grandeur for his family and himself. Pierre Antoine Lepardi Jourdan purchased from Marigny. Louis Cathedral, the Cabildo, the Presbytere, and a piece of property Mr. Among the new buildings in Jackson Square were the St. The Spanish replaced what was left of the wooden buildings with thick brick walled structures that included courtyards, arcades, and wrought iron balconies. During the tragedy, a portion of Pierre Phillipe de Marigny’s mansion was burnt.ĭuring the next decade, the city of New Orleans was in a rebuilding process, trying to recover from the fire that swept the French Quarter. On March 21, 1788, the Great New Orleans Fire started on Good Friday and burned 856 of the 1,100 structures in the French Quarter, including the city’s main church, original Cabildo, the municipal building, the army barracks, armory, and jail.
0 kommentar(er)
